﻿CREATE PROCEDURE SubRubrosArticulos_DevolverPorId

@IdSubRubroArticulo INT

AS

SELECT sra.IdSubRubroArticulo,
	sra.IdRubroArticulo,
	sra.Nombre,
	sra.Observaciones
	FROM SubRubrosArticulos sra
	WHERE sra.IdSubRubroArticulo = @IdSubRubroArticulo